﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Evpo.ContactData.Data
{
    internal class SProcs
    {
        // Contact
        internal const string SaveContact = "SaveContact";
        internal const string GetContacts = "GetContacts";
        internal const string GetContact = "GetContact";
        internal const string DeleteContact = "DeleteContact";

        // Home Town
        internal const string SaveHomeTown = "SaveHomeTown";
        internal const string GetHomeTown = "GetHomeTown";
        internal const string GetHomeTowns = "GetHomeTowns";
        internal const string DeleteHomeTown = "DeleteHomeTown";

        // Contact Interest
        internal const string GetContactInterest = "GetContactInterest";
        internal const string DeleteContactInterest = "DeleteContactInterest";
        internal const string GetContactInterests = "GetContactInterests";
        internal const string SaveContactInterest = "SaveContactInterest";

        // Contact interest of Contact
        internal const string ClearContactInterestsOfContact = "ClearContactInterestsOfContact";
        internal const string AddContactInterestOfContact = "AddContactInterestOfContact";
        internal const string LoadContactInterestsOfContact = "LoadContactInterestsOfContact";
                
        // Title
        internal const string GetTitles = "GetTitles";
        internal const string GetTitle = "GetTitle";
        internal const string DeleteTitle = "DeleteTitle";
        internal const string SaveTitle = "SaveTitle";

        // Marital Status
        internal const string GetMaritalStatuses = "GetMaritalStatuses";
        internal const string GetMaritalStatus = "GetMaritalStatus";

        // Membership Type
        internal const string GetMembershipType = "GetMembershipType";
        internal const string GetMembershipTypes = "GetMembershipTypes";

        // Mail Format
        internal const string GetMailFormat = "GetMailFormat";
        internal const string GetMailFormats = "GetMailFormats";

        // Relationship
        internal const string Relationships = "Relationships";
        internal const string RelationshipTypes = "RelationshipTypes";
        internal const string SaveRelationship = "SaveRelationship";
        internal const string DeleteRelationship = "DeleteRelationship";

        // Address
        internal const string SaveAddress = "SaveAddress";
        internal const string GetAddress = "GetAddress";
        internal const string GetAddresses = "GetAddresses";
        internal const string DeleteAddress = "DeleteAddress";
        internal const string DictionaryIDForUnspecified = "DictionaryIDForUnspecified";
        internal const string GetAddressResidents = "GetAddressResidents";
        
        // Export
        internal const string GetExportTable = "GetExportTable";
        internal const string GetExportRow = "GetExportRow";
    }
}
